USE clothing 

go 

IF EXISTS(SELECT * 
          FROM   sys.objects 
          WHERE  object_id = Object_id(N'attendance') 
                 AND type IN ( N'U' )) 
  BEGIN 
      DROP TABLE attendance 
  END 

go 

CREATE TABLE attendance 
  ( 
     aid     INT IDENTITY(1, 1) NOT NULL, 
     eid     VARCHAR(10) NOT NULL, 
     adate   VARCHAR(10), 
     result  VARCHAR(5) NOT NULL, 
     details NVARCHAR(20), 
     remark  NVARCHAR(200) 
     PRIMARY KEY CLUSTERED ( aid ASC )WITH (ignore_dup_key=OFF) ON [primary] 
  ) 
ON [primary] 

go 